package com.cn.mobileproject.db.table;

import android.provider.BaseColumns;

public class EnterpriseTable implements BaseColumns{

	public static final String TABLE_NAME = "t_enterprise";
	public static final String FIELD_PROJECTID="projectid";
	public static final String FIELD_CONTRACTNAME="contractname";
	
	public static final String FIELD_CONTRACTCODE="contractcode";
	public static final String FIELD_CONTRACTTYPE="contracttype";
	public static final String FIELD_ENTERPRISEID="enterpriseid";
	public static final String FIELD_ENTERPRISENAME="enterprisename";
	public static final String FIELD_DISPLAYVALUE="displayvalue";
	
	

	
	public static final String[] TABLE_COLUMNS = new String[] { 
		 _ID,
	     FIELD_PROJECTID,
	     FIELD_CONTRACTNAME,
	     FIELD_CONTRACTCODE,
	     FIELD_CONTRACTTYPE,
	     FIELD_ENTERPRISEID,
	     FIELD_ENTERPRISENAME,
	     FIELD_DISPLAYVALUE
	};

	public static final String CREATE_TABLE = "create table "
        + TABLE_NAME + " ("        
        	+ FIELD_PROJECTID + " text ,"
        	+ FIELD_CONTRACTNAME + " text ,"
        	+ FIELD_CONTRACTCODE + " long ,"
        	+ FIELD_CONTRACTTYPE + " text ,"
        	+ FIELD_ENTERPRISEID + " text ,"
        	+ FIELD_ENTERPRISENAME + " text ,"
        	+ FIELD_DISPLAYVALUE + " text , "
        	+ " constraint pk_t1 primary key ("
		    + FIELD_PROJECTID+" , "
        	+ FIELD_ENTERPRISEID        	
		    + ")"
	    	+ ")";
}
